SQL Server database extent and pages |
您所在的位置：网站首页 › pages in sql server › SQL Server database extent and pages |
|
I want to ask about the SQL Server database, all I know about database structure is that under the database we have datafiles (.mdf/ndf & LogFile), then extents, then pages, and each extent contains 8 pages (each page is about 8060 KB in size), also I read about fill factore and understood that to get better performance when editing on tables you have to set fill factore for about 75% or something, and if that table is read-only fill factore could be 95 or 100 (if I'm right). What I want to know here is that: Is there one extent created for each new table that I create in the database or a table that can read from multiple extents? (if YES, what happens if I make BULK editing [load much more data] on a table and all of its extent pages filled up [all 8 pages], in this case, is there a new Extent creating to hold the new data for the same table, so the table here will read from two extents? or new pages creating an extent so number increased to 9, not 8 pages?BR, |
| CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |